2025-06-05 19:01:18,376 [ 349545 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2025-06-05 19:01:18,376 [ 349545 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2025-06-05 19:01:18,376 [ 349545 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2025-06-05 19:01:18,376 [ 349545 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_1wrekm --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: order-1.0.1, random-0.2, timeout-2.2.0, repeat-0.9.3, reportlog-0.4.0, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [100 items] scheduling tests via LoadFileScheduling test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_quota/test.py::test_add_remove_interval test_replication_credentials/test.py::test_credentials_and_no_credentials test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_mutations/test.py::test_mutations test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_ssh_keys_authentication/test.py::test_ecdsa test_reloading_settings_from_users_xml/test.py::test_force_reload [gw8] [ 1%] PASSED test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 [gw8] [ 2%] PASSED test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase [gw8] [ 3%] PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw8] [ 4%] PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw4] [ 5%] PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_s3_with_https/test.py::test_s3_with_https[s3_secure] [gw0] [ 6%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] [gw0] [ 7%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] [gw3] [ 8%] FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml [gw2] [ 9%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] [gw0] [ 10%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] [gw0] [ 11%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_and_delete_replicated[USER] test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished [gw4] [ 12%] PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum [gw2] [ 13%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] [gw0] [ 14%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] test_replicated_users/test.py::test_create_replicated[QUOTA] [gw1] [ 15%] PASSED test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota [gw2] [ 16%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] test_replicated_user_defined_functions/test.py::test_create_and_replace [gw0] [ 17%] PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] test_replicated_users/test.py::test_create_replicated[ROLE] [gw4] [ 18%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int [gw5] [ 19%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper [gw0] [ 20%] PASSED test_replicated_users/test.py::test_create_replicated[ROLE] test_replicated_users/test.py::test_create_replicated[ROW_POLICY] [gw2] [ 21%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists [gw4] [ 22%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload [gw2] [ 23%] PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper [gw0] [ 24%] PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] [gw4] [ 25%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw0] [ 26%] PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated[USER] [gw0] [ 27%] PASSED test_replicated_users/test.py::test_create_replicated[USER] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] [gw0] [ 28%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] [gw4] [ 29%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw0] [ 30%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] [gw1] [ 31%] PASSED test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters [gw0] [ 32%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] [gw0] [ 33%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] [gw0] [ 34%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] [gw1] [ 35%] PASSED test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases [gw5] [ 36%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper [gw0] [ 37%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] [gw5] [ 38%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper [gw0] [ 39%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] [gw1] [ 40%] PASSED test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges [gw0] [ 41%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw0] [ 42%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster[USER] [gw1] [ 43%] PASSED test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist [gw0] [ 44%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] [gw0] [ 45%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] [gw1] [ 46%] PASSED test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables [gw0] [ 47%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] [gw1] [ 48%] PASSED test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection [gw3] [ 49%] FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction [gw0] [ 50%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] [gw5] [ 51%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 52%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] [gw0] [ 53%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] [gw5] [ 54%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 55%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] [gw1] [ 56%] PASSED test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management [gw0] [ 57%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] test_replicated_users/test.py::test_reload_zookeeper [gw3] [ 58%] FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss [gw1] [ 59%] PASSED test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota [gw3] [ 60%] FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes [gw2] [ 61%] PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots [gw3] [ 62%] FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw2] [ 63%] PASSED test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation [gw1] [ 64%] PASSED test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts [gw3] [ 65%] FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw2] [ 66%] PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart [gw1] [ 67%] PASSED test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml [gw1] [ 68%] PASSED test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer [gw8] [ 69%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw8] [ 70%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw2] [ 71%] PASSED test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw1] [ 72%] PASSED test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota [gw0] [ 73%] PASSED test_replicated_users/test.py::test_reload_zookeeper test_replicated_users/test.py::test_rename_replicated[QUOTA] [gw0] [ 74%] PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] test_replicated_users/test.py::test_rename_replicated[ROLE] [gw0] [ 75%] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] [gw1] [ 76%] PASSED test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota [gw0] [ 77%] PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] [gw0] [ 78%] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_rename_replicated[USER] [gw0] [ 79%] PASSED test_replicated_users/test.py::test_rename_replicated[USER] [gw1] [ 80%] PASSED test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly [gw1] [ 81%] PASSED test_quota/test.py::test_users_xml_is_readonly test_render_log_file_name_templates/test.py::test_check_file_names [gw4] [ 82%] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw9] [ 83%] PASSED test_replicated_mutations/test.py::test_mutations test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] [gw2] [ 84%] PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper test_replicating_constants/test.py::test_different_versions [gw7] [ 85%] PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials [gw6] [ 86%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] [gw7] [ 87%] PASSED test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials [gw6] [ 88%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] [gw7] [ 89%] PASSED test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials [gw6] [ 90%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw7] [ 91%] PASSED test_replication_credentials/test.py::test_same_credentials [gw6] [ 92%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw8] [ 93%] PASSED test_render_log_file_name_templates/test.py::test_check_file_names [gw9] [ 94%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] [gw4] [ 95%] PASSED test_replicating_constants/test.py::test_different_versions test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw9] [ 96%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] [gw4] [ 97%] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw5] [ 98%] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 [gw5] [ 99%] PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw5] [100%] PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries =================================== FAILURES =================================== _____________________________ test_replicating_dml _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_replicating_dml(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table(f"postgresql_replica_{i}") instance.query( "INSERT INTO postgres_database.postgresql_replica_{} SELECT number, {} from numbers(50)".format( i, i ) ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 50 + number, {i} from numbers(1000)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:100: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.7.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2e15a3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000eff24b4 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d363fc E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x00000000173a87a6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x00000000173a162f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000001739ca9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000017862e10 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000001785f7e0 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x0000000017864110 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177cfb6b E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017dbf13f E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017dbac38 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195edc92 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000001960c2e8 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d16e0a3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d16e912 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d3705c7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d36e890 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d36cd4a E 19. __tsan_thread_start_func @ 0x000000000706b0cf E 20. ? @ 0x00007f450211aac3 E 21. ? @ 0x00007f45021ac850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml PostgreSQL is available - running test ---------------------------- Captured stderr setup ----------------------------- Command:['docker ps | wc -l'] Stdout:1 No running containers Pruning Docker networks Command:['docker network prune --force'] Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] Stdout:net.ipv4.ip_local_port_range = 55000 65535 Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py Cluster start called. is_up=False Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stderr:Error response from daemon: a prune operation is already running Exitcode:1 Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:1 Setup directory for instance: instance Create directory for configuration generated in this helper Create directory for common tests configuration Copy common configuration from helpers Generate and write macros file Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found http://localhost:None "GET /version HTTP/1.1" 200 826 Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] Stderr:Pulling postgres1 ... Stderr:Pulling instance ... Stderr:Pulling postgres1 ... pulling from library/postgres Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... Stderr:Pulling postgres1 ... status: image is up to date for p... Stderr:Pulling postgres1 ... done Stderr:Pulling instance ... pulling from altinityinfra/integr... Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... Stderr:Pulling instance ... status: image is up to date for a... Stderr:Pulling instance ... done Setup Postgres Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown Stderr:docker-py version: Stderr:CPython version: 3.10.12 Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', Stderr: 'BridgeNfIp6tables': True, Stderr: 'BridgeNfIptables': True, Stderr: 'CPUSet': True, Stderr: 'CPUShares': True, Stderr: 'CgroupDriver': 'cgroupfs', Stderr: 'CgroupVersion': '2', Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, Stderr: 'Containers': 0, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': '6d40912a41825ddeaec0cded1887fd184f9a6700a5f330e0c9fd3d0f2a953b23', Stderr: 'Warning': ''} Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.parallel.feed_queue: Pending: {} Stderr:compose.parallel.feed_queue: Starting producer thread for Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], Stderr: 'Links': [], Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, Stderr: 'Mounts': [{'ReadOnly': None, Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', Stderr: 'Target': '/postgres/', Stderr: 'Type': 'bind'}], Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', Stderr: 'PortBindings': {}, Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018', Stderr: 'Warnings': []} Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', Stderr: 'Args': ['postgres', Stderr: '-c', Stderr: 'wal_level=logical', Stderr: '-c', Stderr: 'max_replication_slots=4', Stderr: '-c', Stderr: 'logging_collector=on', Stderr: '-c', Stderr: 'log_directory=/postgres/logs', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018', 'roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['postgres1', '9df1345e7065', 'postgre-sql.local'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018') Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.parallel_execute_iter: Finished processing: Stderr:compose.parallel.feed_queue: Pending: set() get_instance_ip instance_name=postgres1 http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None Can't connect to Postgres connection to server at "172.16.7.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Can't connect to Postgres connection to server at "172.16.7.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Postgres Started ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done ClickHouse instance created get_instance_ip instance_name=instance http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None Waiting for ClickHouse start in instance, ip: 172.16.7.3... http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None ClickHouse instance started Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ------------------------------ Captured log setup ------------------------------ 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:['docker ps | wc -l'] (cluster.py:113, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : No running containers (conftest.py:92, cleanup_environment) 2025-06-05 19:01:22 [ 508 ] DEBUG : Pruning Docker networks (conftest.py:94, cleanup_environment) 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:['docker network prune --force'] (cluster.py:113, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] (cluster.py:113, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:121, run_and_check) 2025-06-05 19:01:22 [ 508 ] INFO : Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py (cluster.py:2659, start) 2025-06-05 19:01:22 [ 508 ] DEBUG : Cluster start called. is_up=False (cluster.py:2666, start) 2025-06-05 19:01:22 [ 508 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-05 19:01:22 [ 508 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-05 19:01:22 [ 508 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-05 19:01:22 [ 508 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-05 19:01:22 [ 508 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-05 19:01:22 [ 508 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-05 19:01:22 [ 508 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-05 19:01:22 [ 508 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-05 19:01:22 [ 508 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-05 19:01:22 [ 508 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Stderr:Error response from daemon: a prune operation is already running (cluster.py:123, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Exitcode:1 (cluster.py:125, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-05 19:01:22 [ 508 ] DEBUG : Setup directory for instance: instance (cluster.py:2679, start) 2025-06-05 19:01:22 [ 508 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4383, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Create directory for common tests configuration (cluster.py:4388, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Copy common configuration from helpers (cluster.py:4408, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Generate and write macros file (cluster.py:4441, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d (cluster.py:4471, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database (cluster.py:4488, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs (cluster.py:4499, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" (cluster.py:4582, create_dir) 2025-06-05 19:01:22 [ 508 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env (cluster.py:86, _create_env_file) 2025-06-05 19:01:22 [ 508 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-05 19:01:22 [ 508 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-05 19:01:22 [ 508 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-05 19:01:22 [ 508 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-05 19:01:22 [ 508 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:546, _make_request) 2025-06-05 19:01:22 [ 508 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] (cluster.py:113, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling postgres1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling instance ... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling postgres1 ... pulling from library/postgres (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling postgres1 ... status: image is up to date for p... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling postgres1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling instance ... pulling from altinityinfra/integr... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling instance ... status: image is up to date for a... (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Stderr:Pulling instance ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:05 [ 508 ] DEBUG : Setup Postgres (cluster.py:2791, start) 2025-06-05 19:02:05 [ 508 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] (cluster.py:113, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:docker-py version: (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:CPython version: 3.10.12 (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'BridgeNfIp6tables': True, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'BridgeNfIptables': True, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'CPUSet': True, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'CPUShares': True, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'CgroupDriver': 'cgroupfs', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'CgroupVersion': '2', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Containers': 0, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': '6d40912a41825ddeaec0cded1887fd184f9a6700a5f330e0c9fd3d0f2a953b23', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Warning': ''} (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {} (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Links': [], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Mounts': [{'ReadOnly': None, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Target': '/postgres/', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Type': 'bind'}], (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'PortBindings': {}, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Warnings': []} (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'Args': ['postgres', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'wal_level=logical', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'max_replication_slots=4', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'logging_collector=on', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr: 'log_directory=/postgres/logs', (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018', 'roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['postgres1', '9df1345e7065', 'postgre-sql.local'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('9df1345e7065ab79525db64d8aa5986c966a9078d7048853f0b4adea1079d018') (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-05 19:02:08 [ 508 ] DEBUG : get_instance_ip instance_name=postgres1 (cluster.py:2008, get_instance_ip) 2025-06-05 19:02:08 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:08 [ 508 ] DEBUG : Can't connect to Postgres connection to server at "172.16.7.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-05 19:02:08 [ 508 ] DEBUG : Can't connect to Postgres connection to server at "172.16.7.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-05 19:02:09 [ 508 ] DEBUG : Postgres Started (cluster.py:2248, wait_postgres_to_start) 2025-06-05 19:02:09 [ 508 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') (cluster.py:3002, start) 2025-06-05 19:02:09 [ 508 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] (cluster.py:113, run_and_check) 2025-06-05 19:02:09 [ 508 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:09 [ 508 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:09 [ 508 ] DEBUG : ClickHouse instance created (cluster.py:3010, start) 2025-06-05 19:02:09 [ 508 ] DEBUG : get_instance_ip instance_name=instance (cluster.py:2008, get_instance_ip) 2025-06-05 19:02:09 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:09 [ 508 ] DEBUG : Waiting for ClickHouse start in instance, ip: 172.16.7.3... (cluster.py:3017, start) 2025-06-05 19:02:09 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:09 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:10 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:11 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:12 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:12 [ 508 ] DEBUG : http://localhost:None "GET /v1.42/containers/99d959d82455b45ba396e969b3b72fd6c2855a6281545c7f13b653618eacd80a/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-05 19:02:12 [ 508 ] DEBUG : ClickHouse instance started (cluster.py:3021, start) 2025-06-05 19:02:12 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:12 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-05 19:02:12 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance (cluster.py:3455, query) 2025-06-05 19:02:12 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance (cluster.py:3455, query) 2025-06-05 19:02:13 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance (cluster.py:3455, query) 2025-06-05 19:02:13 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance (cluster.py:3455, query) 2025-06-05 19:02:13 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance (cluster.py:3455, query) 2025-06-05 19:02:13 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:13 [ 508 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-05 19:02:14 [ 508 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-05 19:02:14 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-05 19:02:14 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-05 19:02:14 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-05 19:02:15 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-05 19:02:15 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-05 19:02:15 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:15 [ 508 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-05 19:02:15 [ 508 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-05 19:02:16 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-05 19:02:16 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:16 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:16 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________ test_restart_server_while_replication_startup_not_finished __________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_restart_server_while_replication_startup_not_finished(started_cluster): NUM_TABLES = 5 pg_manager.create_and_fill_postgres_tables(NUM_TABLES, 100000) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) time.sleep(1) instance.restart_clickhouse() > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:774: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.7.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2e15a3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000eff24b4 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d363fc E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x00000000173a87a6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x00000000173a162f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000001739ca9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000017862e10 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000001785f7e0 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x0000000017864110 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177cfb6b E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017dbf13f E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017dbac38 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195edc92 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000001960c2e8 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d16e0a3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d16e912 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d3705c7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d36e890 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d36cd4a E 19. __tsan_thread_start_func @ 0x000000000706b0cf E 20. ? @ 0x00007f39c7b57ac3 E 21. ? @ 0x00007f39c7be9850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] Stdout: PID TTY TIME CMD Stdout: 8 ? 00:00:10 clickhouse run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] No clickhouse process running. Start new one. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:765 Clickhouse process running. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:765 Executing query select 20 on instance Executing query select 20 on instance Executing query select 20 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-05 19:02:17 [ 508 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-05 19:02:18 [ 508 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-05 19:02:19 [ 508 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-05 19:02:20 [ 508 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-05 19:02:21 [ 508 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-05 19:02:22 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:22 [ 508 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-05 19:02:23 [ 508 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-05 19:02:24 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:24 [ 508 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] (cluster.py:113, run_and_check) 2025-06-05 19:02:24 [ 508 ] DEBUG : Stdout: PID TTY TIME CMD (cluster.py:121, run_and_check) 2025-06-05 19:02:24 [ 508 ] DEBUG : Stdout: 8 ? 00:00:10 clickhouse (cluster.py:121, run_and_check) 2025-06-05 19:02:24 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:24 [ 508 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] (cluster.py:113, run_and_check) 2025-06-05 19:02:24 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:24 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:24 [ 508 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-05 19:02:25 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:25 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:25 [ 508 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-05 19:02:26 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:26 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:26 [ 508 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-05 19:02:27 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:27 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:27 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:27 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:27 [ 508 ] DEBUG : No clickhouse process running. Start new one. (cluster.py:3817, start_clickhouse) 2025-06-05 19:02:27 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:27 [ 508 ] DEBUG : Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:113, run_and_check) 2025-06-05 19:02:29 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:29 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:29 [ 508 ] DEBUG : Stdout:765 (cluster.py:121, run_and_check) 2025-06-05 19:02:29 [ 508 ] DEBUG : Clickhouse process running. (cluster.py:3828, start_clickhouse) 2025-06-05 19:02:29 [ 508 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-05 19:02:29 [ 508 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-05 19:02:29 [ 508 ] DEBUG : Stdout:765 (cluster.py:121, run_and_check) 2025-06-05 19:02:29 [ 508 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-05 19:02:29 [ 508 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-05 19:02:30 [ 508 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-05 19:02:30 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:30 [ 508 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-05 19:02:31 [ 508 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-05 19:02:31 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-05 19:02:31 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:32 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:32 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_single_transaction ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_single_transaction(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, auto_commit=False, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) conn.commit() pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) assert_nested_table_is_created(instance, table_name) for query in queries: print("query {}".format(query)) cursor.execute(query.format(0)) time.sleep(5) result = instance.query(f"select count() from test_database.{table_name}") # no commit yet assert int(result) == 0 conn.commit() > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:531: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.7.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2e15a3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000eff24b4 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d363fc E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x00000000173a87a6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x00000000173a162f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000001739ca9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000017862e10 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000001785f7e0 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x0000000017864110 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177cfb6b E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017dbf13f E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017dbac38 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195edc92 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000001960c2e8 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d16e0a3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d16e912 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d3705c7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d36e890 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d36cd4a E 19. __tsan_thread_start_func @ 0x000000000706b0cf E 20. ? @ 0x00007f39c7b57ac3 E 21. ? @ 0x00007f39c7be9850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database query INSERT INTO postgresql_replica_{} select i, i from generate_series(0, 10000) as t(i); query DELETE FROM postgresql_replica_{} WHERE (value*value) % 3 = 0; query UPDATE postgresql_replica_{} SET value = value - 125 WHERE key % 2 = 0; query UPDATE postgresql_replica_{} SET key=key+20000 WHERE key%2=0 query INSERT INTO postgresql_replica_{} select i, i from generate_series(40000, 50000) as t(i); query DELETE FROM postgresql_replica_{} WHERE key % 10 = 0; query UPDATE postgresql_replica_{} SET value = value + 101 WHERE key % 2 = 1; query UPDATE postgresql_replica_{} SET key=key+80000 WHERE key%2=1 query DELETE FROM postgresql_replica_{} WHERE value % 2 = 0; query UPDATE postgresql_replica_{} SET value = value + 2000 WHERE key % 5 = 0; query INSERT INTO postgresql_replica_{} select i, i from generate_series(200000, 250000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 3 = 0; query UPDATE postgresql_replica_{} SET value = value * 2 WHERE key % 3 = 0; query UPDATE postgresql_replica_{} SET key=key+500000 WHERE key%2=1 query INSERT INTO postgresql_replica_{} select i, i from generate_series(1000000, 1050000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 9 = 2; query UPDATE postgresql_replica_{} SET key=key+10000000 query UPDATE postgresql_replica_{} SET value = value + 2 WHERE key % 3 = 1; query DELETE FROM postgresql_replica_{} WHERE value%5 = 0; Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select count() from test_database.postgresql_replica_0 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-05 19:02:32 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:32 [ 508 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-05 19:02:32 [ 508 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-05 19:02:33 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:38 [ 508 ] DEBUG : Executing query select count() from test_database.postgresql_replica_0 on instance (cluster.py:3455, query) 2025-06-05 19:02:39 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:39 [ 508 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-05 19:02:39 [ 508 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-05 19:02:40 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-05 19:02:40 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:40 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:40 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________________________ test_table_schema_changes ___________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_table_schema_changes(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table( f"postgresql_replica_{i}", template=postgres_table_template_2 ) instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT number, {i}, {i}, {i} from numbers(25)" ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 25 + number, {i}, {i}, {i} from numbers(25)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:371: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.7.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2e15a3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000eff24b4 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d363fc E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x00000000173a87a6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x00000000173a162f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000001739ca9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000017862e10 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000001785f7e0 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x0000000017864110 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177cfb6b E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017dbf13f E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017dbac38 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195edc92 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000001960c2e8 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d16e0a3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d16e912 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d3705c7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d36e890 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d36cd4a E 19. __tsan_thread_start_func @ 0x000000000706b0cf E 20. ? @ 0x00007f39c7b57ac3 E 21. ? @ 0x00007f39c7be9850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-05 19:02:40 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:41 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:41 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:41 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:41 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:42 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:42 [ 508 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-05 19:02:42 [ 508 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-05 19:02:42 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:42 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:43 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:43 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:43 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-05 19:02:43 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:44 [ 508 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-05 19:02:44 [ 508 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-05 19:02:44 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-05 19:02:44 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:45 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:45 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_user_managed_slots ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_user_managed_slots(started_cluster): slot_name = "user_slot" table_name = "test_table" pg_manager.create_and_fill_postgres_table(table_name) replication_connection = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, replication=True, auto_commit=True, ) snapshot = create_replication_slot(replication_connection, slot_name=slot_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, settings=[ f"materialized_postgresql_replication_slot = '{slot_name}'", f"materialized_postgresql_snapshot = '{snapshot}'", ], ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:865: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.7.3:9000. DB::Exception: Unknown table expression identifier 'test_database.test_table' in scope SELECT * FROM `test_database.test_table` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2e15a3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000eff24b4 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d363fc E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x00000000173a87a6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x00000000173a162f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000001739ca9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000017862e10 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000001785f7e0 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x0000000017864110 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177cfb6b E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017dbf13f E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017dbac38 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195edc92 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000001960c2e8 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d16e0a3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d16e912 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d3705c7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d36e890 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d36cd4a E 19. __tsan_thread_start_func @ 0x000000000706b0cf E 20. ? @ 0x00007f39c7b57ac3 E 21. ? @ 0x00007f39c7be9850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.test_table` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "test_table" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) user_slot 0/82C2058 000000DA-00000002-1 Checking table test_table exists in test_database Checking table is synchronized: test_database.test_table ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`test_table` order by key; on instance Executing query select * from `test_database.test_table` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-05 19:02:45 [ 508 ] DEBUG : Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance (cluster.py:3455, query) 2025-06-05 19:02:45 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:45 [ 508 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance (cluster.py:3455, query) 2025-06-05 19:02:45 [ 508 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-05 19:02:46 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:46 [ 508 ] DEBUG : Executing query select * from `postgres_database`.`test_table` order by key; on instance (cluster.py:3455, query) 2025-06-05 19:02:46 [ 508 ] DEBUG : Executing query select * from `test_database.test_table` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-05 19:02:46 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-05 19:02:47 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:47 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:47 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) _____________________________ test_virtual_columns _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_virtual_columns(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) assert_nested_table_is_created(instance, table_name) instance.query( f"INSERT INTO postgres_database.{table_name} SELECT number, number from numbers(10)" ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:553: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.7.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2e15a3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000eff24b4 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d363fc E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x00000000173a87a6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x00000000173a162f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x000000001739ca9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x0000000017862e10 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x000000001785f7e0 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x0000000017864110 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177cfb6b E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017dbf13f E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017dbac38 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195edc92 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x000000001960c2e8 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d16e0a3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d16e912 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d3705c7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d36e890 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d36cd4a E 19. __tsan_thread_start_func @ 0x000000000706b0cf E 20. ? @ 0x00007f39c7b57ac3 E 21. ? @ 0x00007f39c7be9850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-05 19:02:47 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:48 [ 508 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-05 19:02:48 [ 508 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-05 19:02:48 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:48 [ 508 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance (cluster.py:3455, query) 2025-06-05 19:02:49 [ 508 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-05 19:02:49 [ 508 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-05 19:02:49 [ 508 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stdout:Total reclaimed space: 0B Images pruned Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:3 ---------------------------- Captured log teardown ----------------------------- 2025-06-05 19:02:50 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-05 19:02:50 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:50 [ 508 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-05 19:02:50 [ 508 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.7.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-05 19:02:51 [ 508 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] (cluster.py:113, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] (cluster.py:113, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] (cluster.py:113, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default (cluster.py:123, run_and_check) 2025-06-05 19:02:52 [ 508 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-05 19:02:52 [ 508 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-05 19:02:53 [ 508 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-05 19:02:53 [ 508 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-05 19:02:53 [ 508 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-05 19:02:53 [ 508 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-05 19:02:53 [ 508 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-05 19:02:53 [ 508 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-05 19:02:53 [ 508 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-05 19:02:53 [ 508 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-05 19:02:53 [ 508 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:121, run_and_check) 2025-06-05 19:02:53 [ 508 ] DEBUG : Images pruned (cluster.py:854, cleanup) 2025-06-05 19:02:53 [ 508 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-05 19:02:53 [ 508 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-05 19:02:53 [ 508 ] DEBUG : Stdout:3 (cluster.py:121, run_and_check) =============================== warnings summary =============================== test_s3_with_https/test.py::test_s3_with_https[s3_secure] /usr/local/lib/python3.10/dist-packages/urllib3/connectionpool.py:1099: InsecureRequestWarning: Unverified HTTPS request is being made to host '172.16.8.5'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings warnings.warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 301.10s call test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 134.27s setup test_replication_credentials/test.py::test_credentials_and_no_credentials 99.22s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 98.82s setup test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 95.43s setup test_replicated_mutations/test.py::test_mutations 55.67s setup test_replicating_constants/test.py::test_different_versions 53.78s setup test_replicated_user_defined_functions/test.py::test_create_and_drop 53.46s setup test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 51.78s setup test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 50.63s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 50.48s setup test_s3_imds/test_session_token.py::test_credentials_from_metadata 50.29s setup test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 49.52s setup test_quota/test.py::test_add_remove_interval 49.20s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 49.00s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 48.27s setup test_reloading_settings_from_users_xml/test.py::test_force_reload 47.24s setup test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 46.40s setup test_ssh_keys_authentication/test.py::test_ecdsa 45.47s setup test_render_log_file_name_templates/test.py::test_check_file_names 43.82s setup test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 42.48s call test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 40.19s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure] 36.25s call test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 34.33s call test_replicated_mutations/test.py::test_mutations 24.80s call test_replicated_user_defined_functions/test.py::test_reload_zookeeper 23.81s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 23.51s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 22.26s teardown test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 22.15s teardown test_s3_imds/test_session_token.py::test_credentials_from_metadata 22.01s teardown test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 21.97s call test_replicated_users/test.py::test_reload_zookeeper 19.68s call test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 17.29s call test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 15.16s call test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 14.47s call test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 13.33s teardown test_replication_credentials/test.py::test_same_credentials 11.68s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 10.34s teardown test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 9.39s teardown test_replicated_users/test.py::test_rename_replicated[USER] 9.35s teardown test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 7.50s call test_postgresql_replica_database_engine_1/test.py::test_single_transaction 7.31s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 6.76s call test_replicated_user_defined_functions/test.py::test_server_restart 6.61s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 6.51s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 6.28s call test_quota/test.py::test_add_remove_interval 5.39s call test_quota/test.py::test_dcl_introspection 5.32s call test_quota/test.py::test_dcl_management 5.20s call test_quota/test.py::test_add_remove_quota 4.84s teardown test_replicating_constants/test.py::test_different_versions 4.75s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 4.74s call test_replication_credentials/test.py::test_credentials_and_no_credentials 4.62s call test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 4.19s call test_replication_credentials/test.py::test_different_credentials 4.13s teardown test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 4.02s teardown test_quota/test.py::test_users_xml_is_readonly 3.69s call test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 3.68s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 3.64s call test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 3.54s teardown test_render_log_file_name_templates/test.py::test_check_file_names 3.46s call test_quota/test.py::test_reload_users_xml_by_timer 3.40s call test_replication_credentials/test.py::test_no_credentials 3.30s call test_replication_credentials/test.py::test_same_credentials 3.17s call test_quota/test.py::test_exceed_quota 3.10s teardown test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 2.84s call test_replicated_user_defined_functions/test.py::test_replication 2.66s call test_quota/test.py::test_query_inserts 2.54s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 2.39s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 2.34s call test_quota/test.py::test_tracking_quota 2.20s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 2.18s call test_s3_imds/test_session_token.py::test_credentials_from_metadata 2.13s call test_quota/test.py::test_quota_from_users_xml 2.05s call test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 1.93s call test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 1.92s call test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 1.79s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 1.70s teardown test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 1.68s call test_reloading_settings_from_users_xml/test.py::test_force_reload 1.58s call test_replicated_user_defined_functions/test.py::test_create_and_replace 1.53s call test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 1.52s call test_quota/test.py::test_simpliest_quota 1.40s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 1.35s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 1.35s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 1.34s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 1.34s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 1.33s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 1.32s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 1.32s call test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 1.27s call test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 1.25s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 1.20s call test_replicated_users/test.py::test_create_replicated[QUOTA] 1.16s setup test_quota/test.py::test_quota_from_users_xml 1.16s call test_replicated_users/test.py::test_create_replicated[USER] 1.15s call test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 1.15s call test_replicated_users/test.py::test_create_replicated[ROLE] 1.15s call test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 1.08s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 1.07s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 1.00s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 0.99s setup test_quota/test.py::test_consumption_of_show_tables 0.97s setup test_quota/test.py::test_query_inserts 0.97s call test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.96s setup test_quota/test.py::test_dcl_management 0.95s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.94s teardown test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.94s setup test_quota/test.py::test_exceed_quota 0.92s setup test_quota/test.py::test_add_remove_quota 0.92s setup test_quota/test.py::test_dcl_introspection 0.92s setup test_quota/test.py::test_consumption_of_show_processlist 0.92s setup test_quota/test.py::test_consumption_of_show_clusters 0.92s call test_s3_with_https/test.py::test_s3_with_https[s3_secure] 0.92s setup test_quota/test.py::test_consumption_of_show_privileges 0.92s call test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.92s setup test_quota/test.py::test_tracking_quota 0.88s call test_replicated_users/test.py::test_rename_replicated[USER] 0.88s setup test_quota/test.py::test_consumption_of_show_databases 0.87s setup test_quota/test.py::test_simpliest_quota 0.87s setup test_quota/test.py::test_reload_users_xml_by_timer 0.85s teardown test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.83s setup test_quota/test.py::test_users_xml_is_readonly 0.82s call test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.82s call test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.80s teardown test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 0.73s teardown test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.72s call test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.72s teardown test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.71s call test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.71s call test_replicated_users/test.py::test_rename_replicated[ROLE] 0.63s call test_quota/test.py::test_consumption_of_show_processlist 0.63s call test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.62s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.60s call test_replicated_user_defined_functions/test.py::test_create_and_drop 0.58s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.58s call test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.58s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.58s call test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.57s call test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.53s setup test_replication_credentials/test.py::test_different_credentials 0.53s call test_quota/test.py::test_consumption_of_show_clusters 0.53s call test_quota/test.py::test_consumption_of_show_databases 0.53s call test_quota/test.py::test_consumption_of_show_privileges 0.50s setup test_replication_credentials/test.py::test_same_credentials 0.49s setup test_replication_credentials/test.py::test_no_credentials 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.44s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.44s call test_render_log_file_name_templates/test.py::test_check_file_names 0.44s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.43s call test_quota/test.py::test_consumption_of_show_tables 0.41s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.41s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.39s setup test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.36s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 0.33s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.27s call test_replicating_constants/test.py::test_different_versions 0.23s call test_quota/test.py::test_users_xml_is_readonly 0.22s call test_ssh_keys_authentication/test.py::test_ecdsa 0.22s call test_ssh_keys_authentication/test.py::test_ed25519 0.01s teardown test_quota/test.py::test_query_inserts 0.00s teardown test_replicated_mutations/test.py::test_mutations 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure] 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s setup test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s setup test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.00s setup test_replicated_users/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 0.00s teardown test_quota/test.py::test_exceed_quota 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s setup test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s teardown test_quota/test.py::test_consumption_of_show_databases 0.00s teardown test_replication_credentials/test.py::test_credentials_and_no_credentials 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s teardown test_replicated_users/test.py::test_reload_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 0.00s setup test_replicated_users/test.py::test_rename_replicated[USER] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication 0.00s setup test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_force_reload 0.00s setup test_replicated_users/test.py::test_create_replicated[USER] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s teardown test_quota/test.py::test_consumption_of_show_privileges 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s setup test_ssh_keys_authentication/test.py::test_ed25519 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s teardown test_quota/test.py::test_dcl_introspection 0.00s teardown test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated[USER] 0.00s teardown test_quota/test.py::test_consumption_of_show_tables 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s teardown test_quota/test.py::test_dcl_management 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s teardown test_ssh_keys_authentication/test.py::test_ecdsa 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 0.00s teardown test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 0.00s teardown test_quota/test.py::test_consumption_of_show_processlist 0.00s teardown test_quota/test.py::test_add_remove_quota 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s setup test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s teardown test_quota/test.py::test_add_remove_interval 0.00s teardown test_ssh_keys_authentication/test.py::test_ed25519 0.00s teardown test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_user_defined_functions/test.py::test_server_restart 0.00s teardown test_replicated_user_defined_functions/test.py::test_server_restart 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 0.00s teardown test_quota/test.py::test_simpliest_quota 0.00s teardown test_quota/test.py::test_reload_users_xml_by_timer 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s teardown test_quota/test.py::test_quota_from_users_xml 0.00s teardown test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.00s teardown test_quota/test.py::test_tracking_quota 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.00s teardown test_quota/test.py::test_consumption_of_show_clusters 0.00s setup test_replicated_user_defined_functions/test.py::test_replication 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s teardown test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_replication_credentials/test.py::test_different_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s teardown test_replication_credentials/test.py::test_no_credentials =========================== short test summary info ============================ FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns PASSED test_ssh_keys_authentication/test.py::test_ecdsa PASSED test_ssh_keys_authentication/test.py::test_ed25519 PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] PASSED test_quota/test.py::test_add_remove_interval PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated[ROLE] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated[USER] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] PASSED test_quota/test.py::test_add_remove_quota PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] PASSED test_quota/test.py::test_consumption_of_show_clusters PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] PASSED test_quota/test.py::test_consumption_of_show_databases PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] PASSED test_quota/test.py::test_consumption_of_show_privileges PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] PASSED test_quota/test.py::test_consumption_of_show_processlist PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] PASSED test_quota/test.py::test_consumption_of_show_tables PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] PASSED test_quota/test.py::test_dcl_introspection PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] PASSED test_quota/test.py::test_dcl_management PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper PASSED test_replicated_user_defined_functions/test.py::test_replication PASSED test_quota/test.py::test_exceed_quota PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation PASSED test_quota/test.py::test_query_inserts PASSED test_quota/test.py::test_quota_from_users_xml PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] PASSED test_replicated_user_defined_functions/test.py::test_server_restart PASSED test_quota/test.py::test_reload_users_xml_by_timer PASSED test_replicated_users/test.py::test_reload_zookeeper PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] PASSED test_quota/test.py::test_simpliest_quota PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_rename_replicated[USER] PASSED test_quota/test.py::test_tracking_quota PASSED test_quota/test.py::test_users_xml_is_readonly PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility PASSED test_replicated_mutations/test.py::test_mutations PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table PASSED test_replication_credentials/test.py::test_different_credentials PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] PASSED test_replication_credentials/test.py::test_no_credentials PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] PASSED test_replication_credentials/test.py::test_same_credentials PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore PASSED test_render_log_file_name_templates/test.py::test_check_file_names PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] PASSED test_replicating_constants/test.py::test_different_versions PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries ============= 6 failed, 94 passed, 1 warning in 657.43s (0:10:57) ============== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 437, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_1wrekm --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 ' returned non-zero exit status 1.